package com.smartstate.dataManagement.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.smartstate.dataManagement.entity.Attribute;
import com.smartstate.dataManagement.entity.Equipment;
import com.smartstate.dataManagement.entity.EquipmentType;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>设备类型</p>
 * <p>@Author 陈永杰</p>
 * <p>@Date: 2022/8/16</p>
 * <p>@Time: 10:38</p>
 * <p>@version 1.0 <p>
 */
@Mapper
public interface EquipmentTypeMapper extends BaseMapper<EquipmentType> {

    @Select("SELECT id,type,name FROM `equipment_type` ")
    List<EquipmentType> selectEquipmentType();

    @Select("SELECT name FROM `equipment_type` where type = #{type} ")
    String selectByDeviceId(Integer type);
}
